My brother just picked up a nice 04 for a very reasonable price. It's not the most attractive vehicle, but it's not an eye sore either. We've already put a bigger top mount and a mad dad full 3" catback on it and it hauls, both literally and figuratively. (for a man van)
I know you said you prefer wagon over suv, but thought I'd throw it out as an option since it's a mid-sized SUV and meets your other criteria.